﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_CRD_ITEM_BIZ_Change_Card_Cd')
	BEGIN
		DROP Procedure usp_UPDMS_CRD_ITEM_BIZ_Change_Card_Cd
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_CRD_ITEM_BIZ_Change_Card_Cd
**	Desc : 결제카드변경 - 잘못 등록된 카드정보를 수정
**	Test Exec Query : Exec usp_UPDMS_CRD_ITEM_BIZ_Change_Card_Cd 1096, 'smstyle'
**	Called by : Crd_Dac_UPDMS_CRD_ITEM_BIZ.cs
**	Program ID : Crd3012p
**	Auth : 송시명
**	Date : 2010-06-03
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_CRD_ITEM_BIZ_Change_Card_Cd]
@li_seq int,
@ls_card_cd nvarchar(5),
@ls_biz_dt nvarchar(10),
@ls_paymnt_dt nvarchar(10),
@ls_user_id nvarchar(20)
AS
SET NOCOUNT OFF

UPDATE UPDMS_CRD_ITEM_BIZ
   SET Card_Cd = @ls_card_cd,
       Biz_Dt = @ls_biz_dt,
       Paymnt_Dt = @ls_paymnt_dt,
       Update_User = @ls_user_id,
       Update_Dt = GETDATE()
 WHERE Seq = @li_seq

GO